Efficient Evaluation of Aggregates on Bulk Types
نویسندگان
چکیده
A new method for efficiently evaluating queries with aggregate functions is presented. More specifically, we introduce a class of aggregate queries where traditional query evaluation strategies in general require O(n) time and space in the size of the (at most two) input relations. For this class of aggregate queries our approach needs at most O(n log n) time and linear space. Further, our approach deals not only with relations but with general bulk types like sets, bags, and lists.
منابع مشابه
cient Evaluation of Aggregates on Bulk
A new method for eeciently evaluating queries with aggregate functions is presented. More speciically, we introduce a class of aggregate queries where traditional query evaluation strategies in general require O(n 2) time and space in the size of the (at most two) input relations. For this class of aggregate queries our approach needs at most O(n log n) time and linear space. Further, our appro...
متن کاملNumerical study of the development of bulk scale-free structures upon growth of self-affine aggregates.
During the last decade, self-affine geometrical properties of many growing aggregates, originated in a wide variety of processes, have been well characterized. However, little progress has been achieved in the search of a unified description of the underlying dynamics. Extensive numerical evidence is given showing that the bulk of aggregates formed upon ballistic aggregation and random depositi...
متن کاملاثر مدیریت بقایای گیاهی بر ویژگیهای فیزیکی و بیولوژیکی خاک و عملکرد ذرت علوفه ای و جو
The objective of this study was to evaluate the effects of crop residues management on soil physical and biological properties. The impacts of residue management on yield of forage corn and barley and soil micro-organisms population were also studied. The results showed that application of crop residues increased soil organic matter (22.2 %), saturated hydraulic conductivity (51.9 %), porosity ...
متن کاملOptimization of The Cell Aggregates Method for Isolation and Purification of Human Granulosa Cells from Follicular Fluid
Objective Aspirated ovarian follicular fluids (FF) contain luteal granulosa cells (LGC) and other contaminating cell types. Several strategies such as the antibody binding methods, the flask method, the cell strainer, and the positive selection of granulosa aggregates after density gradient centrifugation, were tested as LGCs purification methods. Each of these strategies has its own advantages...
متن کاملمطالعه موردی تاثیر تبدیل مراتع به اراضی کشاورزی بر برخی ویژگی های فیزیکی ، حاصل خیزی ، و شاخص کشت پذیری خاک در بروجن
Due to physiography and weak structure, the pasture soils in Boroojen are potentially degradable. Converting pastures to agricultural land accelerates the degradation processes. A study was conducted in 1999 to show the effects of almost 20 years of farming on originally pasture land on soil physical properties, fertility, and tilth index of pastures in Boroojen region in Chahar Mahal and Bakht...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 1995